-- insert user with admin role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('bfabry'--<username, varchar(25),>
   ,'bfabry'--,'' --<password, varchar(25),>
   ,1--<administrator, tinyint,>
   ,1--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Bre'--<firstName, varchar(50),>
   ,'Fabry' --<lastName, varchar(50),>
   ,'100 East Ave' --<addressLine1, varchar(50),>
   ,'Dorms' --<addressLine2, varchar(50),>
   ,'Waukesha' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53001' --<zipCode, varchar(11),>
   ,'4145551234' --<homePhone, varchar(10),>
   ,'1112229999' --<cellPhone, varchar(10),>
   ,null --<businessPhone, varchar(10),>
   ,'bfabry@pio.carrollu.edu' --<emailAddress, varchar(50),>
   ,'' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with staff role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('cdeerr'--<username, varchar(25),>
   ,'cdeerr' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,1--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Caleb'--<firstName, varchar(50),>
   ,'Deerr' --<lastName, varchar(50),>
   ,'N8999W15021 Main Street' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'Menomonee Falls' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53902' --<zipCode, varchar(11),>
   ,'2626543723' --<homePhone, varchar(10),>
   ,'2625648376' --<cellPhone, varchar(10),>
   ,'4148756372' --<businessPhone, varchar(10),>
   ,'cdeerr@pio.carrollu.edu' --<emailAddress, varchar(50),>
   ,'' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with volunteer role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('jmarty'--<username, varchar(25),>
   ,'jmarty' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,0--<staff, tinyint,>
   ,1--<volunteer, tinyint,>
   ,'Joe'--<firstName, varchar(50),>
   ,'Marty' --<lastName, varchar(50),>
   ,'5510 W Lincoln Ave' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'West Allis' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53214' --<zipCode, varchar(11),>
   ,'4148376832' --<homePhone, varchar(10),>
   ,'' --<cellPhone, varchar(10),>
   ,'' --<businessPhone, varchar(10),>
   ,'jmarty@pio.carrollu.edu' --<emailAddress, varchar(50),>
   ,'' --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO

-- insert user with base user role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('jjones'--<username, varchar(25),>
   ,'jjones' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,0--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Jon'--<firstName, varchar(50),>
   ,'Jones' --<lastName, varchar(50),>
   ,'122 W. State St' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'Madison' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'56122' --<zipCode, varchar(11),>
   ,null --<homePhone, varchar(10),>
   ,null --<cellPhone, varchar(10),>
   ,null --<businessPhone, varchar(10),>
   ,null --<emailAddress, varchar(50),>
   ,null --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO
-- insert user with base user role
INSERT INTO [RedemptoristRetreat].[dbo].[UserAccount]
	([username],[password],[administrator],[staff],[volunteer],[firstName],[lastName],[addressLine1],[addressLine2],[city],[state]
	,[zipCode],[homePhone],[cellPhone],[businessPhone],[emailAddress],[biographyUrl],[activeData])
VALUES
   ('ssmith'--<username, varchar(25),>
   ,'ssmith' --<password, varchar(25),>
   ,0--<administrator, tinyint,>
   ,0--<staff, tinyint,>
   ,0--<volunteer, tinyint,>
   ,'Sam'--<firstName, varchar(50),>
   ,'Smith' --<lastName, varchar(50),>
   ,'12555 W. North Ave' --<addressLine1, varchar(50),>
   ,'' --<addressLine2, varchar(50),>
   ,'Wauwatosa' --<city, varchar(50),>
   ,'WI' --<state, char(2),>
   ,'53216' --<zipCode, varchar(11),>
   ,'4142429087' --<homePhone, varchar(10),>
   ,null --<cellPhone, varchar(10),>
   ,null --<businessPhone, varchar(10),>
   ,null --<emailAddress, varchar(50),>
   ,null --<biographyUrl, varchar(250),>
   ,'1') --<activeData, tinyint,>)
GO





